File manager

File manager - Edit - /home/autoph/public_html/projects/app/Http/Controllers/API/v1/EmployeeBenefitsController.php

Back
<?php namespace App\Http\Controllers\API\v1; use App\Http\Controllers\Controller; use App\Models\Employee; use App\Models\EmployeeBenefits; use Illuminate\Http\Request; use Illuminate\Http\Response; use Illuminate\Support\Facades\Auth; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Validator; use Illuminate\Validation\Rule; use Throwable; class EmployeeBenefitsController extends Controller { public function index(Request $request) { $user = Auth::user(); $keyword = $request->input('keyword', ''); $perPage = $request->input('per_page', PHP_INT_MAX); $sortBy = $request->input('sortBy', ''); $sortType = $request->input('sortType', ''); $dealership_id = $request->input('dealership', null); $data = EmployeeBenefits::with(['employee', 'benefit']) ->where(function ($query) use ($keyword) { $keyword = str_replace(" ", "%", $keyword); $query->where('employee_id', 'like', '%' . $keyword . '%'); }) ->whereHas('benefit'); // Exclude rows without a benefit if (!empty($sortBy) && !empty($sortType)) { $data = $data->orderBy($sortBy, $sortType); } if ($request->id) { $data->where('employee_id', $request->id); } if($user->roles[0]->group_id != 1 && $user->roles[0]->group_id != 2) { $data->whereHas('employee', fn($q) => $q->where('dealer_id', $dealership_id)); } $data = $data->paginate($perPage); return response()->json($data); } public function store(Request $request) { // Validate the incoming request data $validator = Validator::make($request->all(), [ 'employee_id' => [ 'required', ], 'date_from' => [ 'required', ] ]); /** If validation fails return with error message / if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::connection()->beginTransaction(); try { foreach ($request->employee_id as $employee) { $employee_info = Employee::select('company_id', 'dealer_id')->where('employee_id', $employee)->first(); $request['company_id'] = $employee_info->company_id; $request['dealer_id'] = $employee_info->dealer_id; $request['employee_id'] = $employee; $data = EmployeeBenefits::create($request->all()); DB::connection()->commit(); } // $data = EmployeeBenefits::create($request->all()); // DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully added!', 'status' => 'success', ],201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } public function update(Request $request, int $id) { $data = EmployeeBenefits::where('id', $id)->first(); if (!$data) { return response()->json(['messages' => 'No data found.'], 404); } $validator = Validator::make($request->all(), [ 'employee_id' => [ 'required', ], 'date_from' => [ 'required', ] ]); /* If validation fails return with error message */ if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::connection()->beginTransaction(); try { $data->fill($request->all()); $data->save(); $data->touch(); DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully updated!', 'status' => 'success', 'data' => $data, ],201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } public function destroy(int $id) { $data = EmployeeBenefits::find($id); if(!$data) { return response()->json(['message' => "Record not found!"],204); } DB::connection()->beginTransaction(); $data->delete(); DB::connection()->commit(); return response()->json(['message' => "Record successfully deleted!"],201); } }

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.01 | proxy | phpinfo | Settings